inherited frmPosMoneyBill: TfrmPosMoneyBill
  Caption = 'POS'#25910#38134#21592#20986#20837#27454#21333
  PixelsPerInch = 96
  TextHeight = 12
  inherited pnlDBCtrl: TPanel
    inherited lblName: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited lblPrinted: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited dynlblCreate_by: TcxLabel
      AnchorX = 221
    end
    inherited dynlblCheck_by: TcxLabel
      AnchorX = 429
    end
    inherited dynlblFilid: TcxLabel
      AnchorX = 88
    end
    inherited dynlblDeptid: TcxLabel
      AnchorX = 301
    end
    inherited dynlblEmpid: TcxLabel
      AnchorX = 505
    end
    inherited dynlblBKind: TcxLabel
      AnchorX = 149
    end
  end
  inherited Panel1: TPanel
    inherited labFuncName: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited labFuncDesc: TcxLabel
      Style.IsFontAssigned = True
    end
  end
  inherited cxStyleRepository1: TcxStyleRepository
    PixelsPerInch = 96
  end
  inherited MainDataSet: TUniQuery
    SQLInsert.Strings = (
      'INSERT INTO tb_posmoney'
      
        '  (bid, bkind, bstate, bcode, bdate, empid, filid, deptid, creat' +
        'e_by, check_by, chargeid, voucherid, incash, outcash, relationco' +
        'unt, create_time, update_time, check_time, remark, sflag, custom' +
        '1, custom2, custom3, custom4, custom5, custom6, custom7, custom8' +
        ', custom9, custom10, custom11, custom12, custom13, custom14, cus' +
        'tom15)'
      'VALUES'
      
        '  (:bid, :bkind, :bstate, :bcode, :bdate, :empid, :filid, :depti' +
        'd, :create_by, :check_by, :chargeid, :voucherid, :incash, :outca' +
        'sh, :relationcount, :create_time, :update_time, :check_time, :re' +
        'mark, :sflag, :custom1, :custom2, :custom3, :custom4, :custom5, ' +
        ':custom6, :custom7, :custom8, :custom9, :custom10, :custom11, :c' +
        'ustom12, :custom13, :custom14, :custom15)')
    SQLDelete.Strings = (
      'DELETE FROM tb_posmoney'
      'WHERE'
      '  bid = :Old_bid')
    SQLUpdate.Strings = (
      'UPDATE tb_posmoney'
      'SET'
      
        '  bid = :bid, bkind = :bkind, bstate = :bstate, bcode = :bcode, ' +
        'bdate = :bdate, empid = :empid, filid = :filid, deptid = :deptid' +
        ', create_by = :create_by, check_by = :check_by, chargeid = :char' +
        'geid, voucherid = :voucherid, incash = :incash, outcash = :outca' +
        'sh, relationcount = :relationcount, create_time = :create_time, ' +
        'update_time = :update_time, check_time = :check_time, remark = :' +
        'remark, sflag = :sflag, custom1 = :custom1, custom2 = :custom2, ' +
        'custom3 = :custom3, custom4 = :custom4, custom5 = :custom5, cust' +
        'om6 = :custom6, custom7 = :custom7, custom8 = :custom8, custom9 ' +
        '= :custom9, custom10 = :custom10, custom11 = :custom11, custom12' +
        ' = :custom12, custom13 = :custom13, custom14 = :custom14, custom' +
        '15 = :custom15'
      'WHERE'
      '  bid = :Old_bid')
    SQLLock.Strings = (
      'SELECT * FROM tb_posmoney'
      'WITH (UPDLOCK, ROWLOCK, HOLDLOCK)'
      'WHERE'
      '  bid = :Old_bid')
    SQLRefresh.Strings = (
      
        'SELECT bid, bkind, bstate, bcode, bdate, empid, filid, deptid, c' +
        'reate_by, check_by, chargeid, voucherid, incash, outcash, relati' +
        'oncount, create_time, update_time, check_time, remark, sflag, cu' +
        'stom1, custom2, custom3, custom4, custom5, custom6, custom7, cus' +
        'tom8, custom9, custom10, custom11, custom12, custom13, custom14,' +
        ' custom15 FROM tb_posmoney'
      'WHERE'
      '  bid = :Old_bid')
    SQLRecCount.Strings = (
      'SET :PCOUNT = (SELECT COUNT(*) FROM tb_posmoney'
      ')')
    Connection = MainDM.UniConn
    SQL.Strings = (
      'select * from tb_posmoney')
  end
end
